you cannot save to this file format when the VBA project is protected

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jchan - 16 Jul 2006 03:07 GMT

Urgent !!
How can we abe to save the worksheet and at the same time still able to
protect the VBA project coding for viewing ? This development is just like
creating a Template with many macros programming and you do not want the
users go into the project and modify your programs.
It can be done before, why in Excel Visual Basic version 6.3 when you
protect the project for viewing , you workbook can not be saved any more,
unless you unprotect your project coding ?
Your kind solution at this matter is greatly appreciated.
Thanks,
jchan

Reply to this Message

Dave Peterson - 16 Jul 2006 03:42 GMT

This is not the way excel should work. I can protect the project and save the
workbook as often as I like.

If you can't do this, then something is very wrong.

You may want to explain more what you try and what happens.

> Urgent !!
> How can we abe to save the worksheet and at the same time still able to
[quoted text clipped - 10 lines]
> --
> Message posted via http://www.officekb.com

Signature

Dave Peterson

Reply to this Message

jchan - 16 Jul 2006 03:58 GMT

Thanks for your quick response.
I do not recall what happen,may be I hit some button that even realized. I
am a very experienced in Macros coding and delivered a lot of this templates
to many users in the global organization.
This is the first time that happen to me. Some other templates that I
developed do not have this happen.
Do you knwo what is the MicroSoft VBA help desk Email address that I can
send these issues to and ask for solution.
Again, thank you !
Jchan

>This is not the way excel should work. I can protect the project and save the
>workbook as often as I like.
[quoted text clipped - 8 lines]
>> Thanks,
>> jchan

Reply to this Message

jchan - 16 Jul 2006 06:04 GMT

Dave,
I found the solution from vbaexpress.com
Thanks for your help!
jchan
Please read below :
Hi all,
Thx Lucas for your comeback. No its not with all files.

I may have hit on the answer. DRJ mentioned it. I was up real late last night
going through everything looking for an ilregularity, as this is a very
important file.

I have excel set to default save as "Microsoft Excel Workbook(*.xls)". But i
went to try to save the file as a different name and i noticed it was going
to save as
"Microsoft Excel 97-2000 & 5.0/95 Workbook(*.xls)".

Even though they are both .xls they are different formats i think. I don't
know what the difference is, but i'm sure you guys know.

I saved as the first one, and have played with the file for a while, and at
this point it seems to be ok.

I have no idea how the file got saved as the second one.

My issue seems to be solved.

Thx to all for sharing your knowledge.

>This is not the way excel should work. I can protect the project and save the
>workbook as often as I like.
[quoted text clipped - 8 lines]
>> Thanks,
>> jchan

Reply to this Message

Desert Piranha - 16 Jul 2006 03:56 GMT

jchan via OfficeKB.com Wrote:

> Urgent !!
> How can we abe to save the worksheet and at the same time still abl
[quoted text clipped - 14 lines]
> --
> Message posted via http://www.officekb.comHi jchan,

See if there is any information here that will help you.

http://www.vbaexpress.com/forum/showthread.php?t=826

--
Desert Piranh

Reply to this Message

jchan - 16 Jul 2006 05:10 GMT

Desert,
Thanks very much for your prompt attention.
Your suggestion is great.
I went to the vbaexpress.com and found the same issues and followed the
solution.
You know what, it works.
Again, thanks a lot for sharing the knowledge.
jchan

Below are the steps :

Hi all,
Thx Lucas for your comeback. No its not with all files.

I may have hit on the answer. DRJ mentioned it. I was up real late last night
going through everything looking for an ilregularity, as this is a very
important file.

I have excel set to default save as "Microsoft Excel Workbook(*.xls)". But i
went to try to save the file as a different name and i noticed it was going
to save as
"Microsoft Excel 97-2000 & 5.0/95 Workbook(*.xls)".

Even though they are both .xls they are different formats i think. I don't
know what the difference is, but i'm sure you guys know.

I saved as the first one, and have played with the file for a while, and at
this point it seems to be ok.

I have no idea how the file got saved as the second one.

My issue seems to be solved.

Thx to all for sharing your knowledge.

>jchan via OfficeKB.com Wrote:
>> Urgent !!
[quoted text clipped - 9 lines]
>--
>Desert Piranh

Reply to this Message

Desert Piranha - 16 Jul 2006 05:20 GMT

jchan via OfficeKB.com Wrote:

> Desert,
> Thanks very much for your prompt attention.
[quoted text clipped - 5 lines]
> Again, thanks a lot for sharing the knowledge.
> jchanHi jchan,

I'm very glad i was able to help. Hope things go well for you.

Signature

Desert Piranha

Reply to this Message

jchan - 16 Jul 2006 05:33 GMT

Desert,
Again, thank you and admire your devotion on sharing knowledge with others.
good nite, Hope things go well for you and your family.
jchan

>jchan via OfficeKB.com Wrote:
>> Desert,
[quoted text clipped - 4 lines]
>
>I'm very glad i was able to help. Hope things go well for you.

Reply to this Message

Rate this thread: