View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Stop users from inserting new lines and columns?

Right click the excel icon in the upper left corner next to FILEview
codeinsert this. Modify to suitSAVE the workbook

Private Sub Workbook_Open()
Worksheets(1).ScrollArea = "a1:f10"
End Sub

--
Don Guillett
SalesAid Software

"KuroNeko" <none wrote in message
...
Can one stop/prohibit users inserting new lines and columns into a
workbook
in VBA?

How would one proceed?

Neko