Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 1004 when adding a worksheet to an Excel workbook

Status
Not open for further replies.
Slarti

Slarti

Programmer
Feb 5, 2003
45
GB
I'm getting an error message 1004 Unable to get to the Add property of the sheets class when trying to add a worksheet to a workbook. Any ideas as to what could be causing this. I don't get it with every workbook which makes it more annoying! TY.
 
Sort by date Sort by votes
The problem was that the workbook had been protected - Doh!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
356
marty1944
marty1944
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
874
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
125
Swi
Swi
R_a_i_n_e_r_8
  • Locked
  • Question
Compile error: Types of intolerance (need help)
Replies
3
Views
429
strongm
strongm
gmmastros
  • Locked
  • Question
VB6 Post to webservice with MSXML2 error
Replies
4
Views
577
dilettante
dilettante

Part and Inventory Search

Sponsor

Back
Top