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.
--
Thank you, Brenda

What do you mean. Why wouldn't the macros be there?

--


Regards,


Peo Sjoblom

"Brenda" wrote in message
...
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.
--
Thank you, 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.
--
Thank you, Brenda


"Peo Sjoblom" wrote:

What do you mean. Why wouldn't the macros be there?

--


Regards,


Peo Sjoblom

"Brenda" wrote in message
...
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.
--
Thank you, Brenda

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?

Brenda wrote:

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.
--
Thank you, Brenda

"Peo Sjoblom" wrote:

What do you mean. Why wouldn't the macros be there?

--


Regards,


Peo Sjoblom

"Brenda" wrote in message
...
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.
--
Thank you, Brenda




--

Dave Peterson

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?????
--
Thank you, Brenda


"Dave Peterson" wrote:

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?

Brenda wrote:

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.
--
Thank you, Brenda

"Peo Sjoblom" wrote:

What do you mean. Why wouldn't the macros be there?

--


Regards,


Peo Sjoblom

"Brenda" wrote in message
...
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.
--
Thank you, Brenda




--

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 he
http://www.contextures.com/xlvba01.html#Workbook



Brenda wrote:

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?????
--
Thank you, Brenda

"Dave Peterson" wrote:

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?

Brenda wrote:

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.
--
Thank you, Brenda

"Peo Sjoblom" wrote:

What do you mean. Why wouldn't the macros be there?

--


Regards,


Peo Sjoblom

"Brenda" wrote in message
...
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.
--
Thank you, Brenda




--

Dave Peterson


--

Dave Peterson