Hide Row when Sheet Protected

[dj1mtry]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have some PC users and MAC users. We have a problem with protecting a sheet and then hiding rows and columns. In the PC version, there is no problem. With the sheet protected you can hide rows and columns. However, on a MAC, we can not hide rows or columns. We have formulas that must be locked and the sheet must be protected. Is there anyway to hide rows/columns in the MAC version...without unprotecting the sheet?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have some PC users and MAC users. We have a problem with protecting a sheet
and then hiding rows and columns. In the PC version, there is no problem. With
the sheet protected you can hide rows and columns. However, on a MAC, we can
not hide rows or columns. We have formulas that must be locked and the sheet
must be protected. Is there anyway to hide rows/columns in the MAC
version...without unprotecting the sheet?

No, it just works differently. I suggest you reorganize your worksheet to
keep the formula columns permanently hidden. You can protect the windows
version so the columns can not be made visible.

 

[dj1mtry]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have some PC users and MAC users. We have a problem with protecting a sheet
and then hiding rows and columns. In the PC version, there is no problem. With
the sheet protected you can hide rows and columns. However, on a MAC, we can
not hide rows or columns. We have formulas that must be locked and the sheet
must be protected. Is there anyway to hide rows/columns in the MAC
version...without unprotecting the sheet?

No, it just works differently. I suggest you reorganize your worksheet to
keep the formula columns permanently hidden. You can protect the windows
version so the columns can not be made visible.
[/QUOTE]

The only problem with that is, the user has to see the column that the formula is in. It just seems weird that PC users can hid the rows, but MAC cannot. I guess that is just the way it is. This is an order form that some sales people want to hid items that do not apply to a specific customer.

 

[dj1mtry]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I have some PC users and MAC users. We have a problem with protecting a sheet
and then hiding rows and columns. In the PC version, there is no problem. With
the sheet protected you can hide rows and columns. However, on a MAC, we can
not hide rows or columns. We have formulas that must be locked and the sheet
must be protected. Is there anyway to hide rows/columns in the MAC
version...without unprotecting the sheet?

No, it just works differently. I suggest you reorganize your worksheet to
keep the formula columns permanently hidden. You can protect the windows
version so the columns can not be made visible.
[/QUOTE]

The only problem with that is, the user has to see the column that the formula is in. It just seems weird that PC users can hid the rows, but MAC cannot. I guess that is just the way it is. This is an order form that some sales people want to hid items that do not apply to a specific customer.[/QUOTE]

BTW...thanks for the information.