Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 58
Default Hiding Rows in an Automation Addin Function

Does anyone know why this does NOT work?

I have created an Excel automation addin function in .NET (C#) that looks
like this:
public bool HideRow()
{
//_excelApp is set to the valid instance of the current executing Excel
application.
_excelApp.ThisCell.EntireRow.Hidden = true;
return (bool)_excelApp.ThisCell.EntireRow.Hidden;
}

I get no exceptions or errors. The "Hidden" property remains false after I
have set it to true and the row is not hidden in the worksheet. Effectively
nothing happens.

Does anyone have any ideas or suggestions on how to make this work?

Thank you,

Brandon
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unshimmed Automation Addin and Shimmed COM Addin in same App Domai Brandon Excel Programming 0 June 27th 06 11:18 PM
Installing Addin via Automation Aragorn[_2_] Excel Programming 6 October 26th 05 10:54 PM
Referencing a com addin from a .net application via ole automation Luke Excel Programming 3 August 26th 05 01:39 PM
addIn functions in automation nicgendron Excel Programming 1 July 14th 05 10:35 AM
Automation COM Addin with Excel Puneet Excel Programming 0 July 12th 04 07:50 PM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"