hello,
I use a reference to the workbook file name in code that I use to hide different sheets. However, the name of the workbook will change when different users use it. I need to write a code that can hide worksheets without a reference to the file name and without a global reference error.
Thanks A lot!!!
Probably easiest if you can post the code that you are using.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
HTML Code:
You shouldn't need to refer to the workbook if the code is, as I assume, working on a worksheet change event and hiding the sheets within the workbook that contains the code.
Please Login or Register to view this content.
Dom
Thanks a lot. I guess I just need to start getting in the habit of writting the code in single lines.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks