I am half way there. The problem now that I need solved is that I need
to run a macro while it is hidden. When I protect the sheet I cannot
run the macro because it is protected. Any way around this?


---
Message posted from http://www.ExcelForum.com/

What I am doing is copying the result and using paste special to past
it back over. Is there a way I can use VB to Paste Special and past
those resultant values

--
Message posted from http://www.ExcelForum.com

Macros are not protected and will run fine no matter what. In which way do you experience
problems, how do you start the macro ?

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"dgmorr " wrote in message
...
I am half way there. The problem now that I need solved is that I need
to run a macro while it is hidden. When I protect the sheet I cannot
run the macro because it is protected. Any way around this?


---
Message posted from http://www.ExcelForum.com/

The reason I am trying to do this is to reduce the file size. Having al
that extra text from the function creates a much bigger file.

What I do is go to tools/macro/Run Macro. When I put the Protect Shee
mode on, the function will not run

--
Message posted from http://www.ExcelForum.com

What I do is go to tools/macro/Run Macro. When I put the Protect Sheet
mode on, the function will not run.

Ok, if you say so...

Best wishes Harald
Followup to newsgroup only please.

Sub ReduceSize()
ActiveSheet.Unprotect Password:="ABCD"
' perform you actions
ActiveSheet.Protect Password = "ABCD"
End Sub

--
Regards,
Tom Ogilvy

"dgmorr " wrote in message
...
The reason I am trying to do this is to reduce the file size. Having all
that extra text from the function creates a much bigger file.

What I do is go to tools/macro/Run Macro. When I put the Protect Sheet
mode on, the function will not run.


---
Message posted from http://www.ExcelForum.com/