Hi, I have a seemingly simple problem but I can't seem to get around it. Perhaps someone else could enlighten me. When the user closes the workbook, I would like all worksheets except Inputs, SummaryOutput and DetailedOutput to be hidden. My attempt at the code is below:
It's giving me a runtime error 1004- any ideas why? Any help would be greatly appreciated!
Please Login or Register to view this content.
Does this work in place of your For/Next loop
Please Login or Register to view this content.
On what line is the error? Are any sheets being hidden?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Another possible issue is that VBA is case sensitive by default so the string comparisons may not match the actual name of the worksheets - either convert to same case (upper/lower) to compare or includein the General Declarations section of the module.Please Login or Register to view this content.
What it sounds like is its trying to hide all sheets. I believe one has to remain unhidden.
Actually BigBas solved it! The For loop needed brackets as suggested- many thanks to all for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks