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,
--

Steven wrote:
thanks Rob,

would be better if there was a way to lock the page setups though,
because any changes would totally mess up the workbook, good id with
saving the custom views, at least its a quick fix to get them back.

Regards,
Steve

"Rob" wrote in message
...
Steven,

One way which still allows users to set up their own print range is
to set up your print and page settings as you require and then using
the menu
View, Custom View to create a view which you can recall easily.
I
usually add the following VBA code and attach to a button that then
prints the sheet as per my setting. A user could change the Custom
View but most don't know of this.

Hope this is of some use,
Rob

Sub PrintCustomView()
On Error GoTo ErrorMsg
'Enter the named custom view to print in place of PrtRg
Const Cview As String = "PrtRg"
ActiveWorkbook.CustomViews(Cview).Show
ActiveWindow.SelectedSheets.PrintOut 'or PrintPreview
Exit Sub
ErrorMsg:
MsgBox "Error encountered, likely wrong Custom View name.", , "Error"
End Sub

Hi Steve
protect the workbook/worksheet: 'Tools - Protection'

--
Regards
Frank Kabel
Frankfurt, Germany


Steven wrote:
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,

Steven wrote:
thanks Rob,

would be better if there was a way to lock the page setups though,
because any changes would totally mess up the workbook, good id with
saving the custom views, at least its a quick fix to get them back.

Regards,
Steve

"Rob" wrote in message
...
Steven,

One way which still allows users to set up their own print range is
to set up your print and page settings as you require and then
using
the menu
View, Custom View to create a view which you can recall easily.
I
usually add the following VBA code and attach to a button that then
prints the sheet as per my setting. A user could change the Custom
View but most don't know of this.

Hope this is of some use,
Rob

Sub PrintCustomView()
On Error GoTo ErrorMsg
'Enter the named custom view to print in place of PrtRg
Const Cview As String = "PrtRg"
ActiveWorkbook.CustomViews(Cview).Show
ActiveWindow.SelectedSheets.PrintOut 'or PrintPreview
Exit Sub
ErrorMsg:
MsgBox "Error encountered, likely wrong Custom View name.", ,
"Error" End Sub