View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
filo666 filo666 is offline
external usenet poster
 
Posts: 265
Default geting built in dialog info

Hi, I want to offer the user the option of protecting the workbook, the think
is I need to save his password and the selections of the protection dialog
box:

Application.Dialogs(28).Show

how to save the password and the:
..AllowDeletingColumns
..AllowDeletingRows
..AllowFiltering
..AllowFormattingCells
..AllowFormattingColumns
..AllowFormattingRows
.AllowInsertingColumns
.AllowInsertingHyperlinks
.AllowInsertingRows
..AllowSorting
..AllowUsingPivotTables

TIA