I am having excel file, for which I want below features when workbook is open/activated
1. Full screen
2. Hiding Formula Bar
3. Hiding sheets tabs
4. hiding headings,
For this I have created VBA macro as below
UNDER MAIN MODULE
Sub auto_open()
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayWorkbookTabs = False
End Sub
UNDER THIS WORKBOOK
Private Sub Workbook_Activate()
Application.DisplayFormulaBar = False
Application.DisplayFullScreen = True
End Sub
Private Sub Workbook_Deactivate()
Application.DisplayFullScreen = False
Application.DisplayFormulaBar = True
End Sub
Problem which I am facing with above function is that, I am not able to do COPY-PASTE, to and fro, from my file.
I want that my file should have all above 4 features and COPY-PASTE should be allowed TO and FRO, from my file
Also I want to distribute this file, some people will have older version of MS Excel also, so plz provide solution
Seniors plz provide solution
Bookmarks