Workbook_Open() problem in XP

bjr157 · Apr 3rd, 2002, 12:58 PM

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 · Apr 4th, 2002, 11:59 AM

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 · Apr 4th, 2002, 12:01 PM

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

bjr157 · Apr 4th, 2002, 12:06 PM

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 · Apr 4th, 2002, 12:10 PM

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

Apr 4th, 2002, 11:59 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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 __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 3rd, 2002, 12:58 PM	#1
bjr157 Board Regular Join Date: Mar 2002 Location: Philadelphia Posts: 100	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.

Apr 4th, 2002, 12:01 PM	#3
willlobb Board Regular Join Date: Mar 2002 Posts: 103	insted of on_open or whatever it was, its auto_open hope this helps Will

Apr 4th, 2002, 12:06 PM	#4
bjr157 Board Regular Join Date: Mar 2002 Location: Philadelphia Posts: 100	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.

Apr 4th, 2002, 12:10 PM	#5
willlobb Board Regular Join Date: Mar 2002 Posts: 103	have you tried to use auto_open? ps - i just emailed you cos i didnt realise u were online. Will