visit Haymarket Interactive  Atomic  |  PC Authority  |  CRN Australia  |  iTNews  |  PC Authority Business Centre  |  SC Magazine | careers  
Home
Tuesday, 9 February 2010
06:08:48 PM
Users online: 0   You are here >> Home > Tech Talk
LOGIN PASSWORD   forgot my details
Tech Talk
Express your silicon love, hate and curiosity
Forums | Tech Talk Forums search
Forum FAQ
   
  1  
Protected Excel Spreadsheet. How to unlock?
Samson_1 
16/3/07 02:06:09 PM
Overlord

Hey guys...
We had this excel spreadsheet float around the office for a bit over a week now.. And its basically full of photos of bands and you have to name the band... it tells you if you're correct or not..(you may have seen it floating round)
Anyway we've managed about 100 or so but we're all dying to find out the others..
When i click on unprotect workbook, it asks for a password.
When i click view code it comes up with 2 sheets,
One saynig Groups and the other saying cheating Fekker... lol... When i try and change the 2nd one to "visable" it says unable to change the Visable porperty of the worksheet class...

I really really wanna know the answers..
any way around this?

-----
www.ftoaustralia.com

The Tick 
16/3/07 03:20:31 PM
Hero
Titan


Open it with openoffice

-----
"You're not going crazy. You're going sane in a crazy world!"

Samson_1 
16/3/07 03:41:30 PM
Overlord

IS that the only way?
Im at work and cant install anything..
Although i could send it to my home email and do it tonight..
Thanks for the help tick

-----
www.ftoaustralia.com

rahadza 
16/3/07 04:00:56 PM
Learner

there are plenty of programs that do it but if you can't install anything then i guess you'll have to wait till you get home to do it.

-----

B82R3S 
16/3/07 08:12:22 PM
Guru

Quote by The Tick
Open it with openoffice


Does he mean a password protected file? Didnt know it was that easy ahah -1 microsoft.

-----
A64 3000+ @ 2.2Ghz | 1GB DDR400 @ 440 2.5-4-4-7 | FX5200 | DVR-111D | 200GB +120GB HDD | Shuttle Case + new fan |

Haplo 
16/3/07 08:20:50 PM
Master
I think that suckers only worksheet protected.

Here you go.
http://www.theofficeexperts.com/VBASamples/Excel02.htm

-----
aka : Galifang(WoW) + lotsa impressive computer bits, all overclocked!!

robzy 
17/3/07 03:25:41 PM
Hero
Immortal


Quote by Haplo
I think that suckers only worksheet protected.

Here you go.
http://www.theofficeexperts.com/VBASamples/Excel02.htm


Oh, thats very cool.

Rob.

-----
עם ישראל חי

  1  
Forums | Tech Talk