ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Without using protect sheet and adding password to ur sheet can u make ur sheet fixed no insertion process in ur sheet for columns and rows ?

user-image
تم إضافة السؤال من قبل Ahmed Maher allam , Senior IT Consultant & System Admin (Lecturer & Trainier) , KGL
تاريخ النشر: 2015/02/28
مستخدم محذوف‎
من قبل مستخدم محذوف‎

An answer without using the Review tab, in the Changes group, click Protect Workbook, not using the Structure check box?!!

 

A cheat to stop rows or columns being inserted, is to put a character into cells:

 

A1048576

XFD1048576

XFD1

 

This will prevent any new rows or columns being inserted.

Rows and columns at the foot and to the right of the work area can be utilised.

And this method one would need to specify the print range area, otherwise so many blank pages would be printed.

 

This does not prevent overriding of formulas.

 

I really know nothing about VBA; and perhaps Atif's suggestion is the more correct and practical idea.

Atif Tanveer
من قبل Atif Tanveer , Decision Support Specialist , Hamilton Health Science

The alternative is VBA, in reality sheet will be protected through VBA code instead protecting it from menu.

المزيد من الأسئلة المماثلة