Excel help please

  Mike D 15:05 17 Feb 06
Locked

I am sure that this will be a simple one for the Excel experts out there.

A small tutorial business, which charges its students £x per lesson, payable each lesson, currently uses a straight forward workbook, which comprises on sheet per day to log attendance and payments for each student ( obviously with totals for each day and each week). This works fine as up until now the inputting has been done by the proprietor; there will soon be a change and someone else will be working on the Workbook (someone who the proprietor does not want to have access to the whole book). This raises two questions:

1 Can the Workbook be locked except for the current day's register
or
2 Can the current day's register be a separate workbook/sheet, which is linked to the original workbook, which, in turn, would need to be inaccessible to the new person.

Any suggestions gratefully received.

Mike

  VoG II 15:25 17 Feb 06

The easiest option would be to hide the sheets that the proprietor does not want the inputter to see. That should be sufficient unless it is suspected that the inputter will try to unhide hidden sheets. Even then it is possible to make them not appear in the list of sheets that can be unhidden by using a macro along the lines of:

Sub HideEm()
Sheets("Sheet1").Visible = XLVeryHidden
End Sub

To unhide that sheet

Sub UnHideEm()
Sheets("Sheet1").Visible = True
End Sub

  Mike D 15:34 17 Feb 06

Thanks VoG™. I will try this. I have marked as resolved and will repost if necessary.

Mike

This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now