View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RyanH RyanH is offline
external usenet poster
 
Posts: 586
Default Skip Read Only MsgBox with Save As

I have a workbook that is protected, which forces users to open it in Read
Only if they do not have the password. When the user clicks on Save a
Message Box pops up saying "Workbook is Read Only. To Save a copy, Click OK,
then give the workbook a new name in the Save As Dialog Box." Is there a way
to skip the message box and go straight to the Save As Dialog Box?

Thanks in Advance,
Ryan