Not sure if I'm going about this the right way, but I'd like to hide a shape in another worksheet if text is entered in a cell in the first worksheet.
Cell B9 corresponds with one worksheet, B10 with the next worksheet, etc, each with the same named shape in the subsequent worksheet.
As I have it, I'm getting an error that the named object "DoNotUse" is not recognized...
Your help would be appreciated. Thanks!
Please Login or Register to view this content.
Are you unprotecting the sheet when you are running this code?
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
No I have not needed to so far. Once the text box is hidden, what is underneath is unlocked and editable by the user. I just want to be able to control the conditions in which they can edit. Btw, the protection I have in place is without a password.Originally Posted by JapanDave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks