How can i disable or lock the button in the attached file by using vba? thanks
How can i disable or lock the button in the attached file by using vba? thanks
Last edited by karinos57; 04-24-2009 at 10:36 AM.
This piece of code in your macro would do it:
Set that to "true" in another piece of code to make it visible again.Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hello karinos57,
This removes the macro and leaves the shape object visible.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
hi guys i posted a similar question here, im sorry i didnt just reply here but i didnt know how to upload if somone can merge them that would be cool
thanks
You did well not to post a question in someone else's thread. We don't do that.
Entia non sunt multiplicanda sine necessitate
works like a charm. thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks