The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » best training excel intermediate - Excel VBA

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

best training excel intermediate - Excel VBA

Resolved · Low Priority · Version Standard

ReplyTue 27 Nov 2007, 16:36Delegate Florence said...

Excel VBA

Why don't macros work when I hide my main data worksheet?

For upcoming training course dates see: Pricing & availability

ReplyMon 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

Excel articles

· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· Microsoft Excel Cheat Sheet: Tips and Shortcuts
· Mastering Page Layout In Excel
· Create A Basic Timeline In Excel
· Prepare for your MOS Certification with MS Excel Courses

Excel tip:

Hiding a worksheet in Excel

Want to circulate an Excel workbook file but keep certain worksheets hidden from your colleagues' view?

You can do so by bringing up the sheet you wish to hide on your screen; then going to Format - Sheet - Hide.

It will not be immediately obvious that a sheet is hidden from view unless perhaps the sheet are still labelled Sheet 1, Sheet 2 etc.

To display the sheet again, you can go to Format - Sheet - Unhide on any of the other sheets in the workbook. A dialogue box will appear, allowing you to select the hidden sheet/s. Click OK to make the sheet/s reappear again.

View all Excel hints and tips

How do i create a custom filter

» Forum post: Custom filter

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions