Hi all,

Tried Many a times solving this error , however i know this forum is very useful and people really help each other,

My code mentioned below: I am getting the error at Me.Pricing_Owner.AddItem ws.Name,

I want to add a new sheet if any1 from the Pricing_Owner.combobox is new and it should automatically rename with the username.

but its showing run time error 70 permission denied while adding new sheet...


Private Sub UserForm_Initialize()
For Each ws In ThisWorkbook.Worksheets
Me.Pricing_Owner.AddItem ws.Name
Next ws
End Sub


It would be really appreciable if any1 can help me with this....