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?

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?

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?

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 <(E-Mail Removed)> 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?

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?

File>Save As>File 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 <(E-Mail Removed)> 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?