LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dow dow is offline
external usenet poster
 
Posts: 7
Default Check box problem Excel 2003

I have placed several check boxes on a spread sheet using the Forms toolbar.
The spread sheet is read only and protected. The check boxes can still be
selected and moved or deleted. How can this be prevented? Below is the macro
that I am using:

Private Sub Button1_Click()
Range("G1,L9,I13,I14,I15,L22,L34,J36,J38,K44,K45,K 46,K47,K58,L75,L79,K82,L99").Select
Selection.ClearContents
Range("l9").Select
Dim cb As CheckBox

For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb

End Sub
The spread sheet will also be used on Excel 97.
Any assistance would be appreciated.
--
dow
 
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
Microsoft Excel 2003 - Help with Catalog set up / Check out mr19th Excel Worksheet Functions 1 December 16th 08 05:41 PM
How do I add check boxes in Excel 2003? Noah Excel Discussion (Misc queries) 1 January 11th 08 04:30 PM
Copy and paste problem Excel 2003 to Word 2003 [email protected] Excel Discussion (Misc queries) 2 August 28th 07 11:14 AM
How can I add a medical spell check to excel 2003? Lacey New Users to Excel 1 August 14th 07 11:04 AM
Excel 2003 Spell Check Lee Excel Discussion (Misc queries) 0 April 24th 06 02:03 AM


All times are GMT +1. The time now is 06:50 AM.

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

About Us

"It's about Microsoft Excel"