Macro question
 

Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages? Thanks


--

Some mornings it just doesn't seem worth it to gnaw through the leather straps.

....Emo Phillips

Macro question
 

This is just a guess, as I don't have Vista, but you may want to check your
Macro security settings or put a self signed certificate on these workbooks.


HTH,
Barb Reinhardt

"Steve" wrote:

Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages? Thanks


--

Some mornings it just doesn't seem worth it to gnaw through the leather straps.

....Emo Phillips

Macro question
 

Barb Reinhardt wrote:
Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages? Thanks

This is just a guess, as I don't have Vista, but you may want to check your
Macro security settings or put a self signed certificate on these workbooks.

Thanks Barb, but unfortunately that's all Greek to me. Sigh...


--

Some mornings it just doesn't seem worth it to gnaw through the leather straps.

....Emo Phillips

Macro question
 

With Excel 2007 you may be able to get around this for your own personal
files and files from truly trusted sources. It allows you to declare certain
locations (folders) as trusted and will always permit macros in files opened
from those locations to function without any hinderance or warning at all.

Click the Excel Office button, choose the Excel Options button near the
lower right of the window. Choose 'Trust Center' in the next window. Click
the [Trust Center Settings...] button in the window that comes up. Finally,
click the Trusted Locations link in the left pane and add trusted locations
as needed. Put your .xls, .xlsx, .xlsm files into your trusted location.

Hope this helps some.

P.S. Some anti-virus programs also inhibit macros from running - I know
Kaspersky Anti-Virus has that feature, so you may want to check that out also.


"Steve" wrote:

Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages? Thanks


--

Some mornings it just doesn't seem worth it to gnaw through the leather straps.

....Emo Phillips

Macro question
 

Darn it, Steve - I apologize. For some reason I thought you had also moved
to Excel 2007 with your move to Vista. I don't have a setup like that - my
one and only Vista machine also has Excel 2007 on it, not an earlier version.
So all of my rambling about trusted locations in Excel 2007 are probably
totally useless to you. So, like Barb Reinhardt, I'm blind in that area.
Sorry for wasting your time.

"Steve" wrote:

Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages? Thanks


--

Some mornings it just doesn't seem worth it to gnaw through the leather straps.

....Emo Phillips

Macro question
 

JLatham <HelpFrom @ Jlathamsite.com.(removethis) wrote:
Darn it, Steve - I apologize. For some reason I thought you had also moved
to Excel 2007 with your move to Vista. I don't have a setup like that - my
one and only Vista machine also has Excel 2007 on it, not an earlier version.
So all of my rambling about trusted locations in Excel 2007 are probably
totally useless to you. So, like Barb Reinhardt, I'm blind in that area.
Sorry for wasting your time.

No problem, I appreciate your taking the time to respond! Migrating to
a new OS sure isn't much fun. I particularly love the programs
purchased years ago, that now inform me (after being reinstalled) that
I have 30 days to pay up or else. Some of those programs don't even
exist anymore, no way to get it straightened out. ugh ugh ugh


--

Some mornings it just doesn't seem worth it to gnaw through the leather straps.

....Emo Phillips

Macro question
 

Steve wrote:
Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages?

I deleted the macros, still getting the virus message every time I
open the worksheet. Any ideas?


--

When we ask for advice, we are usually looking for an accomplice.

....Marquis de la Grange

Macro question
 

Maybe you didn't clean up everything.

Visit this site from Debra Dalgleish:
http://contextures.com/xlfaqMac.html#NoMacros

Steve wrote:

Steve wrote:
Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages?

I deleted the macros, still getting the virus message every time I
open the worksheet. Any ideas?

--

When we ask for advice, we are usually looking for an accomplice.

...Marquis de la Grange

--

Dave Peterson

Macro question
 

Dave Peterson wrote:
Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages?

I deleted the macros, still getting the virus message every time I
open the worksheet. Any ideas?

Maybe you didn't clean up everything.
Visit this site from Debra Dalgleish:
http://contextures.com/xlfaqMac.html#NoMacros

Thanks Dave. Gotta say, though, it's pretty disgusting to hafta go
thru this...


--

When we ask for advice, we are usually looking for an accomplice.

....Marquis de la Grange

Macro question
 

Steve wrote:
Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages?

Maybe you didn't clean up everything.
Visit this site from Debra Dalgleish:
http://contextures.com/xlfaqMac.html#NoMacros

Tried this, got nowhere - no Project Explorer onscreen. Is this really
the only way to remove a macro in Excel? Seems utterly ridiculous...


--

When we ask for advice, we are usually looking for an accomplice.

....Marquis de la Grange

Macro question
 

Inside the VBE
View|Project Explorer
(or hit ctrl-r)



Steve wrote:

Steve wrote:
Just moved Excel from an XP PC to a Vista PC. Whenever I open a
worksheet containing macros, I get a message about macros containing
viruses. I click Enable, but still don't have the toolbar button
shortcuts for the macros. I've moved the .xlb file and the
personal.xls file, is there something else I need to move? And how do
I get rid of those virus messages?

Maybe you didn't clean up everything.
Visit this site from Debra Dalgleish:
http://contextures.com/xlfaqMac.html#NoMacros

Tried this, got nowhere - no Project Explorer onscreen. Is this really
the only way to remove a macro in Excel? Seems utterly ridiculous...

--

When we ask for advice, we are usually looking for an accomplice.

...Marquis de la Grange

--

Dave Peterson