Excel Macro to enter same text in comment box file's property box of 132 different files

#11

Posted to microsoft.public.excel.programming

Kat[_8_]

external usenet poster

Posts: 8

Excel Macro to enter same text in comment box file's property box of 132 different files

On May 9, 10:38 am, Jan Karel Pieterse
wrote:
Hi Kat,

Thanks so much for the help. But the macro errors out here.

What is the error?

Regards,

Jan Karel Pieterse
Excel MVPhttp://www.jkp-ads.com
Member of:
Professional Office Developer Associationwww.proofficedev.com

Here is where it errors out
ActiveWorkbook.Worksheets(wsName).PrintOut

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
Button / Shortcut to extranal file's macro?	Andrew	Excel Discussion (Misc queries)	3	June 12th 08 10:37 PM
Is there a way to enter a comment on a locked cell in Excel?	BJ	Excel Worksheet Functions	1	April 4th 08 02:07 PM
how to default WritePassword under excel workbook property for any files as long as those files are the offsprings of the parent file	George	Excel Programming	0	October 5th 06 04:14 PM
FORMAT COMMENT TEXT WITH MACRO	Sunil Patel	Excel Programming	4	June 30th 05 05:13 PM
Prompted to convert the file's text encoding...	Darryl	Excel Discussion (Misc queries)	0	March 1st 05 08:49 PM

All times are GMT +1. The time now is 02:29 PM.

Menu

About Us