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 SkipVought 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
0
0
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
169
marty1944
marty1944
2009luca
difficult to crteate a query very complicated 1
Replies
9
Views
621
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Read Excel Sharepoint File
Replies
0
Views
63
Swi
Swi
R_a_i_n_e_r_8
  • Locked
  • Question
Compile error: Types of intolerance (need help)
Replies
3
Views
203
strongm
strongm
gmmastros
  • Locked
  • Question
VB6 Post to webservice with MSXML2 error
Replies
4
Views
276
dilettante
dilettante

Part and Inventory Search

Sponsor

Back
Top