<div>
Hi <br />
Question?<br />
Did you close your aplication before open the Spreadsheet?
</div>


Hi
Question?
Did you close your aplication before open the Spreadsheet?

<div>
Could you paste the code of your function here?
</div>


Could you paste the code of your function here?

<div>
Have found the answer thanks....<br />
the line of code to stop it happening is:<br />
wbk.Parent.Windows(wbk.Nam<wbr />e).Visible<wbr /> = True<br />
<br />
where wbk is my Excel object.<br />
Thanks again<br />
Jay
</div>


Have found the answer thanks....
the line of code to stop it happening is:
wbk.Parent.Windows(wbk.Name).Visible = True

where wbk is my Excel object.
Thanks again
Jay

<div>
<div class="content wysiwyg-content">
I have a function which (successfully) opens a worksheet and deletes a particular row.. all is good.<br />
But when I then manually go and open the spreadsheet the (only) worksheet is hidden and I need to go to format-sheet-unhide.<br />
Any ideas why this would happen?<br />
VB6/Excel 2k<br />
<br />
Jay
</div>
</div>


I have a function which (successfully) opens a worksheet and deletes a particular row.. all is good.
But when I then manually go and open the spreadsheet the (only) worksheet is hidden and I need to go to format-sheet-unhide.
Any ideas why this would happen?
VB6/Excel 2k

Jay

VB/Excel question

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.