Jak w *.xls usunąć autora komentarza?

Article View: pl.comp.lang.vbasic

Article #92268

Back to pl.comp.lang.vbasic Previous Next

#92268

From: juras
Date: Thu, 20 Oct 2005 21:06

15 lines
1306 bytes

Witam
Mam mniej więcej taki kawałek kodu, gdzie usuwam sobie listy, przyciski
etc.ale w przypadku komentarza chciałbym usunąć informacje o autorze. Tylko
jak??

for nr =  ActiveSheet.Shapes.count to 1 step -1
if  ActiveSheet.Shapes(nr).name <>"Comment" then
    ActiveSheet.Shapes(nr).Delete
else
    Usuń/zmień autora komentarza, tylko jak?
endif
next

pozdrawiam
jurek

Technical Details

Message-ID: <d7b21$435806bd$3eb35d81$963@news.chello.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsfeed01.chello.at!newsfeed02.chello.at!news.chello.pl.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.nask.pl!news.nask.org.pl!news.germany.com!newsfeed01.sul.t-online.de!t-online.de!newsfeed01.chello.at!newsfeed02.chello.at!news.chello.pl.POSTED!not-for-mail
From: "juras" <jurrekm@poczta.onet.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Jak w *.xls usunąć autora komentarza?
Date: Thu, 20 Oct 2005 23:06:05 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <d7b21$435806bd$3eb35d81$963@news.chello.pl>
X-Complaints-To: abuse@chello.pl
Organization: chello.pl
Lines: 17
NNTP-Posting-Host: 62.179.93.129 (62.179.93.129)
NNTP-Posting-Date: Thu, 20 Oct 2005 23:06:05 +0200
X-Trace: d7b21435806bd9b16f82400963
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit