PC Review


Reply
Thread Tools Rate Thread

Command Button protection problems????

 
 
Chris Watson
Guest
Posts: n/a
 
      25th Feb 2006

I have out together a workbook that contains several Command Buttons,
but even though I have unlocked the command button when I protect the
sheet I can't use the button, Excel keeps flashing up an error saying
that it read only. I have been into tools-options and the read only tab
is not checked. What am I doing wrong.

Please help


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=516451

 
Reply With Quote
 
 
 
 
dmexcel
Guest
Posts: n/a
 
      25th Feb 2006
could you elaberate more, I don't quite understand what you mean,
where did you get the button from??
explain how you created the buttons??

 
Reply With Quote
 
Chris Watson
Guest
Posts: n/a
 
      25th Feb 2006

I have used a Command Button from the control toolbox and linked a cell
which gives me a True or False return which I need, but when I protect
the work sheet the Command Button won't work. I get a message to
un-protect the workbook before I can use it. I have been into the
properties of the button and unlocked it, I just can't understand why
It will not let me use it.


--
Chris Watson
------------------------------------------------------------------------
Chris Watson's Profile: http://www.excelforum.com/member.php...fo&userid=4700
View this thread: http://www.excelforum.com/showthread...hreadid=516451

 
Reply With Quote
 
dmexcel
Guest
Posts: n/a
 
      25th Feb 2006
Hmm!, I can't get that to happen!
are you still in design mode??

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Command Button Problems Cindy M. Microsoft Word Document Management 0 19th Jan 2007 10:52 AM
How do I fix problems with a command button? =?Utf-8?B?Q0o=?= Microsoft Access 0 7th Jun 2006 05:34 PM
Command Button problems Anna Peters via AccessMonster.com Microsoft Access VBA Modules 1 24th Apr 2005 11:40 AM
Command Button Problems TMSpurr Microsoft Access Forms 2 7th Sep 2004 06:29 AM
Command Button Protection Mark1 Microsoft Excel Misc 1 6th Feb 2004 02:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:48 PM.