More Page Setup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

azutjw - 15 May 2008 23:18 GMT

Same situation, next level: is there a way to 'save' the setup so that I can
apply it to the read-only file each time I view/print it? I especially like
to add date/time and my initials, but I realize I can't set that up in the
'master'.

Reply to this Message

Jim Thomlinson - 16 May 2008 00:06 GMT

Possible... yes... But not necessarily easy. What you need to do is to put a
macro in your personal xl workbook (or create an addin but that is a bit more
difficult). The macro will act on each sheet in your group of selected sheets
to give you the proper page setup. If you want to proceed with that just
reply back...

Signature

HTH...

Jim Thomlinson

> Same situation, next level: is there a way to 'save' the setup so that I can
> apply it to the read-only file each time I view/print it? I especially like
> to add date/time and my initials, but I realize I can't set that up in the
> 'master'.

Reply to this Message

azutjw - 16 May 2008 15:18 GMT

Hmm - yes, I can see that (now)...I'm a Mechanical Design Engineer (30+ yrs),
and although I've done some programming - even a couple pretty hairy ones - I
keep just enough in my active memory to maintain current ops; I've got some
books and manuals, and it sounds like it may be fun to dig it out myself and
try it, maybe even productive - - especially now I know where and how to
look. Thanks again, Jim!jw

> Possible... yes... But not necessarily easy. What you need to do is to put a
> macro in your personal xl workbook (or create an addin but that is a bit more
[quoted text clipped - 6 lines]
> > to add date/time and my initials, but I realize I can't set that up in the
> > 'master'.

Reply to this Message