Workbook_Open() problem in XP

[bjr157]

i just started using office XP. It seems that excel XP does run my ON OPEN macros the way excel 97 did, it just ignores them. How do I get XP macros to run when the spreadsheet is opened. thanks.

 

[Jack in the UK]

Hi not uncommon XP has additions 97 does notknow and improvements justthe slightest bit will stop it.

suggest record or write in XP or debug and post effected line we will try to solve.

HTH

Rdgs

 

[willlobb]

insted of on_open or whatever it was, its auto_open
hope this helps
Will

 

[bjr157]

the code is simply displaying a userform

UserForm1.show

XP ignore the macro all together, is there a difference in how it recognizes macros that are initiated when the workbook is opened? i had some problems with the new security settings (before no macros wouldnt even run), but i figured it out to put the security on low, but it still refuses to run macros on open???????? i thought it would be a universal problem that others were have but maybe not.

 

[willlobb]

have you tried to use auto_open?
ps - i just emailed you cos i didnt realise u were online.
Will