UDF is not working on a protected sheet in Excel 2003

C

CarpeDiem

How Can I make this function to work on a protected sheet (Excel version: 2003)

The Code:

Function LSUser()
LSUser = Environ("username")

End Function

Much appreciated if I could get the answer for this issue :). The function
works fine on a protected sheet in Excel:2007, In Excel: 2003 it doesn't
changes the name if a new user updates the worksheet. All the cells in the
worksheet are write protected except for some on which the user enters the
information and then saves it. The worksheet was designed and created in
excel 2003.
 

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

UDF doesn't work on a protected sheet in Excel 2003 1
Protected Worksheet Tab Order 1
Allow Insert Rows in a protected worksheet 2
Autofilter not working on protected sheet. 1
Protected Excel Worksheet 1
Sheet protection problem 1
corrupted formula in protected worksheet 21
Excel 2003 - how to check is all worksheet is protected 1

Top