Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running Code on Hidden Worksheet
We have a basic workbook that managers use to record comments (good or bad)
about other managers. When an entry is made, the manager's name is entered in column A, the date in column B and the comment in column C. The workbook is available to all managers. However, when a manager opens it, we don't want him/her to see any entries made about themselves; rather, they can see only entries about other managers. I've successfully created code that captures the user's Windows login name as a means to hide any row containing their name. The code starts by selecting the first cell in column A (which I call "Start"), looking down that column for any instances of the user's name, and hiding the row. Protection is then applied to prevent users from unhiding the rows. My challenge is how to have this code run while that worksheet is hidden, then only display it after the user's rows have been hidden (I want to hide the worksheet upon opening because I don't want the user to have a temporary glimpse of it before the code actually runs). Because my code starts with Range("Start").Select, I get an error message because the worksheet is hidden to begin with. Thanks in advance for any help/suggestions for overcoming this issue! -- Steve C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro running against hidden worksheet | Excel Discussion (Misc queries) | |||
how to prevent code running when in a worksheet code | Excel Programming | |||
Code to access a hidden worksheet | Excel Programming | |||
Running code on hidden sheets (revisited) | Excel Programming | |||
Running code on hidden sheets | Excel Programming |