Write-only sheet

[brems]

Hello,

I may be posting it in the wrong place but I don't know if it can be done without a macro.

I have an excel sheet (input) where the user has to complete some fields. On the sheet there is a button to transmit the entered data to another sheet. Let's call this sheet MainSheet.

The user must be able to
- write to the MainSheet (by entering input on the inputsheet and transmitting the data to the MainSheet) This is done with a macro.
- consult the MainSheet without the ability to change the entered data.

In other words: is it possible to secure the MainSheet so the user can still write and look at it but can't change it anymore?

Thanks in advance
Wim

 

[Jon von der Heyden]

Hi Wim

You can protect the worksheet and thus prevent entry, and yet still allow the macro to write to the protected sheet.

This achieved by setting the protection UserInterfaceOnly argument to True.

See this MSDN topic on the Protect Method which includes a remark about UserInterfaceOnly.

 

[brems]

Hi Jon,

Thank you very much for the link. I'll try this later this day and I'll keep you posted.
Have a nice day!

Wim