Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

Programmatically adding code to worksheet

Hi,

When I need to add code to a worksheet, I rightclick on the sheet tab
bearing the sheetname, choose "View Code" and, paste the code.

Is there a way to do this programmatically as I have to insert the
worksheet code in 65 sheets.

Thanks in advance for the help.

Raj

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Programmatically Adding Code to a Workbook	Chaplain Doug	Excel Programming	1	August 24th 06 09:03 PM
Programmatically Adding Code to a Workbook	Chaplain Doug	Excel Programming	0	August 24th 06 04:27 PM
Adding "WorkbookOpen" Code Programmatically	[email protected]	Excel Programming	1	May 15th 06 08:58 AM
Adding checkboxes programmatically to a worksheet	Stef	Excel Programming	2	February 1st 05 03:53 PM
Programmatically adding buttons to a worksheet (Shape Object)	Phil	Excel Programming	3	January 26th 04 03:51 PM

All times are GMT +1. The time now is 08:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us