Trouble with macros in excel

Triple J · 01-09-2008, 05:12 AM

Hi,

Im trying to create macros in excel, but when i try to set them up it comes up saying something about it not being able to be created because the security levels are set to high so it gradually got dropped down and is now currently set on low and yet it still wont work.

Any ideas?

Thanks,

**Glaswegian** · 01-09-2008, 06:10 AM

How are you creating your macros? Using the macro recorder or just typing the code directly into a VBA panel?

Did you change the security via Tools > Options > Security > Macro Security? It should be set to Medium.

Triple J · 01-09-2008, 06:24 AM

Typing in code, ive had the security settings on all but non seem to make a difference.

explodingmatt · 01-09-2008, 07:28 AM

What version of Excel is it?
You might be better off using the Macro recorder to sort it out.

Triple J · 01-09-2008, 07:36 AM

its 2003 edition of excel

**Glaswegian** · 01-09-2008, 11:59 AM

Try some of these troubleshooting tips

http://www.officearticles.com/excel/...soft_excel.htm

01-09-2008, 05:12 AM	#1 (permalink)
Triple J Registered User Join Date: Jan 2008 Posts: 6 OS: win2000	Trouble with macros in excel Hi, Im trying to create macros in excel, but when i try to set them up it comes up saying something about it not being able to be created because the security levels are set to high so it gradually got dropped down and is now currently set on low and yet it still wont work. Any ideas? Thanks,

01-09-2008, 06:10 AM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,427 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Trouble with macros in excel How are you creating your macros? Using the macro recorder or just typing the code directly into a VBA panel? Did you change the security via Tools > Options > Security > Macro Security? It should be set to Medium. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

01-09-2008, 06:24 AM	#3 (permalink)
Triple J Registered User Join Date: Jan 2008 Posts: 6 OS: win2000	Re: Trouble with macros in excel Typing in code, ive had the security settings on all but non seem to make a difference.

01-09-2008, 07:28 AM	#4 (permalink)
explodingmatt Registered User Join Date: Jan 2008 Location: Lancashire Posts: 3 OS: XP SP2	Re: Trouble with macros in excel What version of Excel is it? You might be better off using the Macro recorder to sort it out.

01-09-2008, 07:36 AM	#5 (permalink)
Triple J Registered User Join Date: Jan 2008 Posts: 6 OS: win2000	Re: Trouble with macros in excel its 2003 edition of excel

01-09-2008, 11:59 AM	#6 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,427 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Trouble with macros in excel Try some of these troubleshooting tips http://www.officearticles.com/excel/...soft_excel.htm __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner