S
Steven
i originally posted this in excel.printing:
how would I go bout protecting a WS print_area? so that other users who work
on the WB cant mess up page breaks and page layouts?
Many thanks,
Steve
Have you asked in microsoft.public.excel.programming? I've a book here that
tells you how to completely remove options from the toolbar using VBA, so
you could set up your workbook to do that when it gets opened and then
restore the menus when the book is closed. There are probably tidier ways of
doing similar things as well.
I would provide it here for you, but I haven't really got my head around
that subject (yet).
Paul C,
--
how would I go bout protecting a WS print_area? so that other users who work
on the WB cant mess up page breaks and page layouts?
Many thanks,
Steve
Have you asked in microsoft.public.excel.programming? I've a book here that
tells you how to completely remove options from the toolbar using VBA, so
you could set up your workbook to do that when it gets opened and then
restore the menus when the book is closed. There are probably tidier ways of
doing similar things as well.
I would provide it here for you, but I haven't really got my head around
that subject (yet).
Paul C,
--