LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Maverick2U
 
Posts: n/a
Default Creating a check box that does not require security clearance.

I'm trying to create a simple check box that returns a value into a cell (for
instance A1). I create the check box and put A1 in the "LinkedCell" section
under Properties. This places a TRUE or FALSE into A1. Now every time I open
the spreadsheet I have to chose to enable macros. If I share this file whit
others who have high security settings, they won't even be able to open it.
This file is going to unsophisticated users and this simple check box may
make it so that they can't even use the file. Is there a way to fix it so
that this isn't seen as a "custom" macro?

If I create a check box but have the value of the check box appear nowhere
on the sheet, the security does not bother it.

Thanks.
 
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
Creating Formula using check boxes Anthony Slater Excel Discussion (Misc queries) 3 January 4th 05 03:03 PM


All times are GMT +1. The time now is 07:09 PM.

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"