Excel / Protection/ Emailing

[denice]

Greetings
I have created an exel spreadsheet with protection and hidden fields/columns. I have gone to FORMAT>Protection and locked everything. Then I protect the sheet. When its emailed, the end user is able to change fields, and the hidden fields/columns are now visible. IS there anything that Im doing that needs corrected and or can anyone explain why?

Thanks

Denice
Mac OSX, Running Classic for Quark 4.1. System G4.

 

[Dreamboat]

Denice:

You can protect all you want using VBA code, but if the user has his Macro Security level set to high, then he's not allowing code, so your code don't run.

That's my guess. Either that or he's disabling macros to begin with.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[KatherineCoombs]

Denice, are you protecting the spreadsheet through VBA or the inbuilt Excel functionality?

 

[denice]

There are no macros on the spreadsheet, just formatting protection cells. Then I click on PROTECT SHEET and enter a password twice. No VBA. Im on a Mac.

Denice
Mac OSX, Running Classic for Quark 4.1. System G4.

 

[Dreamboat]

Ah.

There are ways.

See this:

http://www.theofficeexperts.com/VBASamples/Excel02.htm

Some people might think I shouldn't post that information on the web. But I post it as much for people like you who may think that password protection is infallible, as I do for people who may have truly forgotten a password.

Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX

 

[denice]

Dreamboat, thank you for posting the way to crack a spreadsheet. I highly doubt that my end users are attempting to "crack" my spreadsheet. I hid and protected the fields so they wouldnt be confused by them. I send it out one way and I get it back with deleted columns. My end users are photographers and arent really sure how they made it possible for their TV's to be so small with a type writer attached.
If anyone would be willing to view my attached spreadsheet and see why my fields arent protected, i would be very greatful.

Regards
Debi

Denice
Mac OSX, Running Classic for Quark 4.1. System G4.

 

[KatherineCoombs]

I can't see any attachment, but you're welcome to email it to me directly on katherine_coombs@bigpond.comCan you also reference some columns and cells that should be protected etc??