• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Autolock cells after data entry without using VBA

SKi

New Member
Hi Everyone,

i am trying to create & save an excel sheet in one drive or a teams group accessible to multiple users. the multiple users can go in and book seats for themselves. i tried using the VBA code, but the problem faced is that in my workstation the code works but in other users workstations the sheet runs like a simple excel.

i am looking for a solution on excel to autolock the cell after data entry by any of the user so that other person cannot overwrite on same.

Request your help!
 
SKi
Please reread Forum Rules
especially part of How to get the Best Results at Chandoo.org

One possible for You would be something like
Before Close Your file,
Activate/Select 'empty-sheet' and
set to other sheets .Visible = xlSheetVeryHidden

After that save Your file.
While Open Your file,
change all .Visible = xlSheetVisible
and
change that 'empty-sheet' .Visible = xlSheetVeryHidden
If someone uses that file without Macros,
then those would see ... only 'empty-sheet'.
 
SKi
Please reread Forum Rules
especially part of How to get the Best Results at Chandoo.org

One possible for You would be something like
Before Close Your file,
Activate/Select 'empty-sheet' and
set to other sheets .Visible = xlSheetVeryHidden

After that save Your file.
While Open Your file,
change all .Visible = xlSheetVisible
and
change that 'empty-sheet' .Visible = xlSheetVeryHidden
If someone uses that file without Macros,
then those would see ... only 'empty-sheet'.
Thank you for your response back...my question is that the excel file will be on a common place with access to say 300 people. Is their any formula wherein the cells get autolocked if 1 user writes in 1 particular cell. Basically, second user cannot overwrite that cell
 
SKi
Seems You skipped my writings about Forum Rules..
After that You would eg notice that You should open this thread to Ask an Excel Question, if You'll avoid VBA.
... by formula?

... of course, users could swap manually that cells protection to unlocked/locked for editing and
take care that protection would be on before save/close that file.
... but still other user would by mistake overwrite that cell.
... with VBA there would be some possibilities to do this too.
 
Back
Top