98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » best training excel intermediate - Excel VBA
best training excel intermediate - Excel VBA
Resolved · Low Priority · Version Standard
Tue 27 Nov 2007, 16:36Delegate Florence said...
Florence has attended:
Excel VBA Intro Intermediate course
Excel VBA
Why don't macros work when I hide my main data worksheet?
Mon 10 Dec 2007, 10:32Trainer Carlos said...
RE: Excel VBA
Hi Florence
Macros need to physically access the sheets that contain the data to be manipulated.
If a sheet is hidden the system cannot access it. To get around this:
In the code you need to unhide the relevant sheet, thenrun the relevant code and then rehide the sheet. The code is:
Sheets("Sheet3").Visible = True 'Unhides Sheet3
<The code to manipulate data>
Sheets("Sheet3").Visible = False 'Hides Sheet3
Hope this helps
Carlos
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Screen Splitters in ExcelScreen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter. |
