Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Frames and buttons
I know this seems like a small problem but I am dying over this. I have a
spreadsheet that is a user is to paste info into. The user shall then press a button and then a macro is executed. This works. My problem is that I do not want to have a macro simply placed on the spreadsheet since the user can move, delete etc. the button. Therefore I want to have the button placed in some form of a container or embedded into the spreadsheet. However none of this works for me. If I try to use the Frame anything that I try to put inside the frame becomes invisible. Also when trying to embed the button onto the spreadsheet it cannot be connected to a macro. I do not understand why I have these problems! Please help me out if you have any clue! I really have tried to figure it out! Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Frames and buttons
Hello Sallie Mae, You can protect the objects on the worksheet by going to Tools Protection Protect Sheet... and clear the Contents and Scenarios checkboxes by clicking them. Use a password for added protection. Repeat this for each sheet that has objects you don't moved, or deleted. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=558157 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) | Excel Discussion (Misc queries) | |||
freezing frames | Excel Worksheet Functions | |||
Problem with Frames in userform | Excel Programming | |||
group/frames | Excel Programming | |||
Forms and Frames | Excel Programming |