Hello
I am unable to run the VBA if my sheet is hided.
Kindly suggest.
Regards
Vinay
Hello
I am unable to run the VBA if my sheet is hided.
Kindly suggest.
Regards
Vinay
Can you please provide some additional details?
Are you trying to run a macro against a sheet that is hidden? Trying to kick off a macro that is triggered by a button on a hidden sheet?
There are some extremely talented people here who I'm sure can help - the more details you can give them, the better!
Yes,
I am trying to run a macro against a sheet that is hidden and using a Button in sheet which not hidden.
To unhide before running: Right click on the sheet names at the bottom of the page, select UNHIDE, then pick the right sheet.
To unhide in the code: at the beginning of your macro, add
then to rehide it,![]()
Please Login or Register to view this content.
If you don't want any of this to be seen by the users, add this to the top of your macro:![]()
Please Login or Register to view this content.
and this to the end![]()
Please Login or Register to view this content.
-- this will prevent the screen from updating while the macro runs![]()
Please Login or Register to view this content.
Hope this helps!
It is working...
That's great!
Don't forget to mark this thread as SOLVED when you have a chance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks