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?

Check Box Macro
 

Look into making your VBA into an add-in.
--
Gary''s Student - gsnu200793


"bjh" wrote:

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?

Check Box Macro
 

My guess would be to protect the sheet and save as "macro enabled workbook"
in the file type dropdown when saving. I don't know 100% but you can try.

"bjh" wrote:

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?

Check Box Macro
 

Purchase a Digital Certificate from one of the purveyors of DC's like Thawte or
Verisign

Help gives you more details about signing a workbook under "about digital
signatures"


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 12:16:03 -0700, bjh wrote:

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?

Check Box Macro
 

I'm new to using VBA how would I go about making it into an add-in?

"Gary''s Student" wrote:

Look into making your VBA into an add-in.
--
Gary''s Student - gsnu200793


"bjh" wrote:

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?

Check Box Macro
 

FileSave AsFile Type MS Excel Add-in(*.xla)

Way down at the bottom of the dialog box.


Gord

On Tue, 24 Jun 2008 12:47:00 -0700, bjh wrote:

I'm new to using VBA how would I go about making it into an add-in?

"Gary''s Student" wrote:

Look into making your VBA into an add-in.
--
Gary''s Student - gsnu200793


"bjh" wrote:

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?