Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) KJ7 Excel Discussion (Misc queries) 14 December 3rd 16 10:03 AM
freezing frames Bob Griendling Excel Worksheet Functions 4 July 1st 06 10:58 PM
Problem with Frames in userform JUAN Excel Programming 2 October 27th 04 12:13 AM
group/frames libby Excel Programming 2 April 1st 04 01:47 PM
Forms and Frames Shunt Excel Programming 5 August 1st 03 12:28 AM


All times are GMT +1. The time now is 05:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"