Run time error 70 Permission denied.

**sagar.rajula** · 04-09-2013, 04:40 AM

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

**:) Sixthsense :)** · 04-09-2013, 04:56 AM

You may be having REFERENCE in Row Source Property of that Combobox, please check and confirm

**AndyLitch** · 04-09-2013, 05:01 AM

Please Login or Register  to view this content.

**sagar.rajula** · 04-09-2013, 08:50 AM

Hi Sixth,

Thank you for your reply, however the Combobox rowsource is alright and its working fine.

Hi Andy,

Thanks to you also for your kind help howevert I have tried this also , but not working ... I m not able to recognize why is the error arriving ....

Many thanks in advance.

**Kyle123** · 04-09-2013, 09:10 AM

You cannot have a rowsource set and use AddItem, you must use one or the other

**sagar.rajula** · 04-10-2013, 11:50 AM

Yes ... but I am just adding sheet ... I am familiar with VB...

Can u please let what will be code ...

I want if a combobox is selected then it should 1st check within all the worksheet in workbook whether it contains the sheet name of that combobox value & if it is available then it should directly divert to that sheet .... ... and if not then it should insert a new sheet along with the value of the combobox ...

I hope this information will help you to assist me ...

Many thanks,

Regards.