Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
bjh bjh is offline
external usenet poster
 
Posts: 2
Default Check Box Macro

I've created a spreadsheet with various checkboxes throughout it to replace
an older version. Unfortunately the old version is protected and I don't
know the password so I had to start from scratch. Both versions have
checkboxes but only the new one gives a Security Warning stating "Macros may
contain viruses. It is usually safe to disable macros, but if the macros are
legitimate, you might lose some functionality."
The spreadsheet is going to be distributed to clients so I can't just change
my security settingsget rid of the message. If I leave it there and someone
doesn't allow the macro they can't use the checkbox.

How do I get the spreadsheet to not give a Security Warning but still keep
the checkboxes active?
 
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
Customized Macro Button Check [email protected] Excel Discussion (Misc queries) 1 August 11th 07 12:23 AM
To be safe - how to check macro before run it? Eric Excel Discussion (Misc queries) 2 April 21st 06 12:31 AM
need macro to check part# and sum jg53 Excel Worksheet Functions 8 April 13th 06 04:29 PM
how do i create a macro for putting a check in a box? Dakota Bleu Excel Worksheet Functions 1 December 19th 05 02:05 AM
How do I link a check box to a macro? Tom Excel Worksheet Functions 1 April 12th 05 04:37 AM


All times are GMT +1. The time now is 03:30 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"