Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
How do you run a macro when a reference is on a supper hidden sheet. I am
getting an error if it is hidden. If not it works. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
Always nice to start a new thread with YOUR question instead of hijacking an
old one. Also, always nice to show us your code for comments. I suspect that you have code that is SELECTING the sheet when it probably isn't necessary. -- Don Guillett Microsoft MVP Excel SalesAid Software "Jeremy" wrote in message ... How do you run a macro when a reference is on a supper hidden sheet. I am getting an error if it is hidden. If not it works. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
The code has to go to the hidden sheet. I figured it out. Thanks you for
the imput. "Don Guillett" wrote: Always nice to start a new thread with YOUR question instead of hijacking an old one. Also, always nice to show us your code for comments. I suspect that you have code that is SELECTING the sheet when it probably isn't necessary. -- Don Guillett Microsoft MVP Excel SalesAid Software "Jeremy" wrote in message ... How do you run a macro when a reference is on a supper hidden sheet. I am getting an error if it is hidden. If not it works. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
How exactly are you referring to the cell in the macro? (code please!)
Could always try something like: Application.ScreenUpdating = False Sheets("YourSheet").Visible = xlVisible 'rest of code goes here Sheets("YourSheet").Visible = xlVeryHidden Application.ScreenUpdating = True -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jeremy" wrote: How do you run a macro when a reference is on a supper hidden sheet. I am getting an error if it is hidden. If not it works. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
This is what I was needing. Thank you for your help.
"Luke M" wrote: How exactly are you referring to the cell in the macro? (code please!) Could always try something like: Application.ScreenUpdating = False Sheets("YourSheet").Visible = xlVisible 'rest of code goes here Sheets("YourSheet").Visible = xlVeryHidden Application.ScreenUpdating = True -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jeremy" wrote: How do you run a macro when a reference is on a supper hidden sheet. I am getting an error if it is hidden. If not it works. Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
You probably could have and SHOULD have used code that did not require
SELECTING. You should try to learn how to do it properly. -- Don Guillett Microsoft MVP Excel SalesAid Software "Jeremy" wrote in message ... This is what I was needing. Thank you for your help. "Luke M" wrote: How exactly are you referring to the cell in the macro? (code please!) Could always try something like: Application.ScreenUpdating = False Sheets("YourSheet").Visible = xlVisible 'rest of code goes here Sheets("YourSheet").Visible = xlVeryHidden Application.ScreenUpdating = True -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Jeremy" wrote: How do you run a macro when a reference is on a supper hidden sheet. I am getting an error if it is hidden. If not it works. Thanks |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Help
Code can operate on veryhidden sheets.
Post your code. Gord Dibben MS Excel MVP On Tue, 1 Sep 2009 06:47:02 -0700, Jeremy wrote: How do you run a macro when a reference is on a supper hidden sheet. I am getting an error if it is hidden. If not it works. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |