Won't save my changes

B

Brenda

I have created a excel program (I am using Excel 2003). When i apply my
macros the work great but...when i save it and close out the file and go back
in my changes are there; however, the macros are still in the file though.
please help i have been working on this for hours. Any help would be
appreciated.
 
B

Brenda

When i apply my macro to the specific sheet using the following formula:
Sub Workbook_Open()
Sheets("ExpenseNortheast3quarter").ScrollArea = "h1:h45"
End Sub



then i save the document but when i close the document and bring it back up
the macros are not applied.
 
D

Dave Peterson

Are you saving the file as a normal workbook (*.xls) or some sort of text file
(*.prn or *.csv)?

Are you sure you're putting that code into the correct workbook's project?
 
B

Brenda

I am so frustrated i have done everythin i know how. I am saving it as a .xls
and i am applying the formula listed below to the correct page. I stated that
it works well until i save close out and reopen then it isn't applied. Can
someone help me?????
 
D

Dave Peterson

Is the code still there or is the problem that the code doesn't run?

I just read your original post.

I'm guessing that you're not putting the code in the correct location.

This workbook_open event belongs in the ThisWorkbook module.

Debra Dalgleish shares some instructions here:
http://www.contextures.com/xlvba01.html#Workbook
 
Top