assigning a macro to an open workbook.

nuozek · Mar 19th, 2002, 06:51 AM

thx
nuozek

[ This Message was edited by: nuozek on 2002-03-19 06:36 ]

GeorgeB · Mar 19th, 2002, 07:04 AM

Right click on the tab, Select view code, In the VBE click on the drop window that says (General). Click on Worksheet. Click on the next window to the right that says Declarations Then click on Activate and put your code in there.
Good luck.
George

nuozek · Mar 19th, 2002, 07:35 AM

nailed it, i figuired my mistake earlier, thx

nuozek · Mar 19th, 2002, 07:35 AM

nailed it, i figuired my mistake earlier, thx

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

Mar 19th, 2002, 06:51 AM	#1
nuozek New Member Join Date: Mar 2002 Posts: 16	thx nuozek [ This Message was edited by: nuozek on 2002-03-19 06:36 ]

Mar 19th, 2002, 07:04 AM	#2
GeorgeB Board Regular Join Date: Feb 2002 Location: Las Vegas Nevada USA Posts: 240	Right click on the tab, Select view code, In the VBE click on the drop window that says (General). Click on Worksheet. Click on the next window to the right that says Declarations Then click on Activate and put your code in there. Good luck. George

Mar 19th, 2002, 07:35 AM	#3
nuozek New Member Join Date: Mar 2002 Posts: 16	nailed it, i figuired my mistake earlier, thx