problem with excel macro workbook activate event

[gj112045]

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

 

[SirJB7]

Hi, gj112045!

This file has the same VBA code you posted, it behaves as you required, and has no copy & paste features disabled. Are you sure that there's no more code involved?

http://dl.dropbox.com/u/60558749/problem%20with%20excel%20macro%20workbook%20activate%20event%20%28for%20gj112045%20at%20chandoo.org%29.xlsm

Regards!