Macro not showing up/missing under TOOLSMACRO or VBE
 

Weird one...

We just upgraded from O2k to O2k3 and a user has a workbook that contains
macros (we have Macro security set to medium and get the enable/disable
macro dialog--I choose enable)

When I click TOOLSMACROS, there is no Macro showing. I googled a bit and
check in VBE under TOOLSREFERENCES, there is nothing showing as missing.
Nothing shows up in VBE.

I hjave copied the file onto my machine with the same results. I tried
opening with Excel 2000 and it is still missing. Have even tried using Open
Office 2.0 and nothing shows up, yet even under OpenOffice, I get warnings
about macros....

Any ideas?

Thanks in advance.

Macro not showing up/missing under TOOLSMACRO or VBE
 

Check out this link...
http://www.contextures.com/xlfaqMac.html#NoMacros
--
HTH...

Jim Thomlinson


"Rubin Farr" wrote:

Weird one...

We just upgraded from O2k to O2k3 and a user has a workbook that contains
macros (we have Macro security set to medium and get the enable/disable
macro dialog--I choose enable)

When I click TOOLSMACROS, there is no Macro showing. I googled a bit and
check in VBE under TOOLSREFERENCES, there is nothing showing as missing.
Nothing shows up in VBE.

I hjave copied the file onto my machine with the same results. I tried
opening with Excel 2000 and it is still missing. Have even tried using Open
Office 2.0 and nothing shows up, yet even under OpenOffice, I get warnings
about macros....

Any ideas?

Thanks in advance.

Macro not showing up/missing under TOOLSMACRO or VBE
 

Wow!

Thanks for the speedy and informative reply, Jim!

This looks to be the solution!

Again..thanks a million!


"Jim Thomlinson" wrote in message
...
Check out this link...
http://www.contextures.com/xlfaqMac.html#NoMacros
--
HTH...

Jim Thomlinson


"Rubin Farr" wrote:

Weird one...

We just upgraded from O2k to O2k3 and a user has a workbook that contains
macros (we have Macro security set to medium and get the enable/disable
macro dialog--I choose enable)

When I click TOOLSMACROS, there is no Macro showing. I googled a bit and
check in VBE under TOOLSREFERENCES, there is nothing showing as missing.
Nothing shows up in VBE.

I hjave copied the file onto my machine with the same results. I tried
opening with Excel 2000 and it is still missing. Have even tried using
Open
Office 2.0 and nothing shows up, yet even under OpenOffice, I get
warnings
about macros....

Any ideas?

Thanks in advance.