Protect a singlw Cell in Excell via VBA

[sanjibkrjana]

Hi,
I am new to this forum.

I am currently developing a automated excell for bill of material in excell

For that I nedd to protect the top two rows (1 & 2)
So that no user can change data in this two rows

& also want to copy all the buttons with its macros assigned to it to all the sheets even to a new sheet when it is created

Hope somebody will help

Thanks in advance

[Fettertiger]

Hi sanjibkrjana,

you could use this:

Please Login or Register  to view this content.

Regards

Theo