Excel 97 shared file

G

Guest

I need to unhide rows with vba in a protected shared file, on Excel 97.

But in Excel 97, it's impossible to unlock a shared file, and then vba
refuses to the unlock function, and refuse to unhide a row on a protected
worksheet.

Please help. Someone have a solution
 
F

Frank Kabel

Hi
shared files have a lot of restrictions and this is one of them (you
can't change the protection of a shared workbook)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shared Workbook Crash 0
Macro can not unprotect a sheet in a shared workbook 4
Exel VBA 1
Save as problem for Excel 97/2000 (with VBA-protection in excel 20 3
excel 2007 errors on chart changes 1
Filter a protected shared worksheet 18
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Programatically filter a protected shared workbook 4

Top