• 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.

Excel hangs up if cells are locked (excel 2013)

S

Suril

Member
Hello,

I recently created an elaborate template for my team. This helped everybody enormously and I owe a lot to this site for the guidance that it gave me.

The template that I create is quite efficient - it is of approx 8MB and runs smoothly. The only problem that I face is that once I lock most of the cells and almost all the sheets, excel hangs very often while someone is working on the template. This template has been created and it is used on excel 2013.

Kindly provide me some solution for this!
 
Hi Suril,

Is your template based on VBA? Or is there any VBA code running in the background?
Does the problem occur when anybody works on the template, or only some people?

BR
 
Aurelie said:
Hi Suril,

Is your template based on VBA? Or is there any VBA code running in the background?
Does the problem occur when anybody works on the template, or only some people?

BR
Click to expand...
Hi Aurelie,

My template is based on VBA and there are certain event triggering vba codes but none too heavy.

My simple point is this - absolutely no problem occurs if the template is used without password protection. Let me give you a simple example:

There is a sheet in which some cells are unlocked and the rest all cells in the entire sheet are locked. If by mistake someone pressed ctrl + A and all the cells are selected then mostly excel gets hanged. Or say A1:D100 is unlocked and rest are locked and there is certain data which I have copied and have to paste in a sheet - the data should have 4 columns only but if by mistake, data with 5 columns is selected and is pasted, excel gets hanged!!
 
Hi Suril,

It seems that your problem comes from your VBA code which does not take into account all options. Do you have a strong error handling structure in your code which woud prevent errors from occuring when a user does something which is not foreseen?

Without seeing the code it is complicated to give you a more precise answer, but if I were you I would start there.

Hope it helps anyway,
BR,
 
Hi, Suril!
As @Aurelie suggested you, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you. Thank you.
Regards!
 
You must log in or register to reply here.
Back
Top