Hi,
I got the following code from this forum which can open a workbook in Design mode by putting it in ThisWorkbook - Thank you very much.
Private Sub Workbook_Open()
Application.CommandBars.FindControl(Id:=1605).Execute
End Sub
Problem:
I am copying a sheet of workbook to create a new workbook using VBA. Original workbook should be in run mode and new workbook should be in design mode (because I don't want the codes (worksheet_change) in the sheet module to run while editing) . Can I insert above code into ThisWorkbook of new workbook while copying or is there any other way?
Thanks, Anil
Bookmarks