Hiya,

I am looking for a way to stop users from being able to hide/unhide
rows in a shared spreadsheet.

Can anyone help out please?

Many thanks

You can apply sheet protection!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

Unfortunately Sheet protection will not work on a shared spreadsheet.

Unfortunately Sheet protection will not work on a shared spreadsheet.

Why not?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

On Thursday, June 26, 2014 10:04:27 PM UTC+1, GS wrote:
Unfortunately Sheet protection will not work on a shared spreadsheet.



Why not?


The only options under protect shared workbook refer to sharing with tracked changes. Excel does not allow structure protection in a shared book.

On Thursday, June 26, 2014 10:04:27 PM UTC+1, GS wrote:
Unfortunately Sheet protection will not work on a shared
spreadsheet.



Why not?


The only options under protect shared workbook refer to sharing with
tracked changes. Excel does not allow structure protection in a
shared book.

I wasn't referring to 'protect shared workbook'! You can apply sheet
protection to a shared workbook, which doesn't have anything to do with
'protect shared workbook'!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

The only options under protect shared workbook refer to sharing with

tracked changes. Excel does not allow structure protection in a

shared book.



I wasn't referring to 'protect shared workbook'! You can apply sheet

protection to a shared workbook, which doesn't have anything to do with

'protect shared workbook'!


Once you share a workbook the protect workbook functions get disabled and the protect structure options get ignored.

I wasn't referring to 'protect shared workbook'! You can apply sheet

protection to a shared workbook, which doesn't have anything to do with

'protect shared workbook'!


Hi Garry,

Won't this also disable the insert rows function? I need to be able to keep the ability to insert Rows and delete rows and just disable the hide row functions.

I wasn't referring to 'protect shared workbook'! You can apply sheet

protection to a shared workbook, which doesn't have anything to do
with

'protect shared workbook'!


Hi Garry,

Won't this also disable the insert rows function? I need to be able
to keep the ability to insert Rows and delete rows and just disable
the hide row functions.

Look at the options in the 'protect sheet' dialog to see all what you
can allow. Certainly 'anything' is possible if your project manages
data table rows/cols via VBA. This is how I handle protected sheets
because it ensures that when users insert/delete rows/cols the
worksheet's 'design structure' doesn't get 'broken'! Otherwise, if your
project's worksheets don't implement a 'design structure' then all bets
are OFF!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion